import pyodbc

server = 'localhost'
database = 'licenseplate'
username = 'sa'
password = '123456'
cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER='+server +
                      ';DATABASE='+database+';UID='+username+';PWD=' + password)

cursor = cnxn.cursor()

cursor.execute("select * from users")

for row in cursor.fetchall():
    print(row)

cursor.execute("INSERT INTO brand (name, country) VALUES (?, ?)",
               ('本田', '日本'))

cnxn.commit()

cnxn.close()
